﻿<%@ Page Title="Admin" Language="C#" MasterPageFile="~/MasterPages/MasterPage.master" AutoEventWireup="true" CodeFile="Admin.aspx.cs" Inherits="Admin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <link href="App_Themes/Default/Default.css" rel="stylesheet" />
    <style type="text/css">
        .auto-style1 {
            width: 100%;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MenuPlaceHolder" Runat="Server">
     <%-- Menu --%>
    <asp:Menu ID="Menu1" runat="server" CssClass="MainMenu" Orientation="Horizontal" onmenuitemclick="Menu1_MenuItemClick">
        <Items>
            <asp:MenuItem NavigateUrl="~/Default.aspx" Text="Trang chủ" Value="HomePage"></asp:MenuItem>
            <asp:MenuItem Text ="Thoát" Value="SignOut"></asp:MenuItem>
        </Items>
    </asp:Menu>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="SidebarPlaceHolder" Runat="Server">
    <asp:Menu ID="Menu2" runat="server"  CssClass="Sidebar">
        <Items>
            <asp:MenuItem  Text="Tài khoản Sinh viên" Value="SinhVien" NavigateUrl="~/Admin.aspx?type=SinhVien"></asp:MenuItem>
            <asp:MenuItem  Text="Tài khoản Giáo viên " Value="GiangVien" NavigateUrl="~/Admin.aspx?type=GiangVien"></asp:MenuItem>
            <asp:MenuItem  Text="Tài khoản PĐT" Value="PDT" NavigateUrl="~/Admin.aspx?type=PhongDaoTao"></asp:MenuItem>
            <asp:MenuItem  Text="Tài khoản Admin" Value="Admin" NavigateUrl="~/Admin.aspx?type=Admin"></asp:MenuItem>
        </Items>
    </asp:Menu>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="MainContentPlaceHolder" Runat="Server">

    <div class="About_Title">
        <asp:Label ID="Label1" runat="server" Text="Label" Font-Bold="True" Font-Size="Larger"></asp:Label>
    </div><br />
    <div class ="Timkiem">
        
                     <asp:TextBox ID="TextBox1" runat="server" Font-Size="Larger" Height="26px" Width="130px"></asp:TextBox>
                   
                    &nbsp;&nbsp;&nbsp;
                   
                    <asp:Button ID="Button1" runat="server" Text="Tìm kiếm" Height="34px" OnClick="Button1_Click1" Width="111px" />

                     <asp:TextBox ID="TextBox2" runat="server" Font-Size="Larger" Height="26px" Width="130px"></asp:TextBox>
                   
                    &nbsp;&nbsp;&nbsp;
                   
                    <asp:Button ID="Button2" runat="server" Text="Tìm kiếm" Height="34px" Width="111px" />
    </div>
    <div class ="Formviews">
        <asp:FormView runat ="server" ID ="FormviewTimKiemSV" DataSourceID="SqlDataSource5" DataKeyNames="MSSV" CellPadding="4" ForeColor="#333333">
            <EditItemTemplate>
                <table class="auto-style1">
                    <tr>
                        <td>MSSV</td>
                        <td>
                            <asp:Label ID="MSSVLabel1" runat="server" Text='<%# Eval("MSSV") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Password</td>
                        <td>
                            <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>HoTen</td>
                        <td>
                            <asp:TextBox ID="HoTenTextBox" runat="server" Text='<%# Bind("HoTen") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Email</td>
                        <td>
                            <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>DiaChi</td>
                        <td>
                            <asp:TextBox ID="DiaChiTextBox" runat="server" Text='<%# Bind("DiaChi") %>' />
                        </td>
                    </tr>
                </table>
                <br />
                <asp:Button ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
                &nbsp;<asp:Button ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
            </EditItemTemplate>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <ItemTemplate>
                <table class="auto-style1">
                    <tr>
                        <td>MSSV</td>
                        <td>
                            <asp:Label ID="MSSVLabel" runat="server" Text='<%# Eval("MSSV") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Password</td>
                        <td>
                            <asp:Label ID="PasswordLabel" runat="server" Text='<%# Bind("Password") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>HoTen</td>
                        <td>
                            <asp:Label ID="HoTenLabel" runat="server" Text='<%# Bind("HoTen") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Email</td>
                        <td>
                            <asp:Label ID="EmailLabel" runat="server" Text='<%# Bind("Email") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>DiaChi</td>
                        <td>
                            <asp:Label ID="DiaChiLabel" runat="server" Text='<%# Bind("DiaChi") %>' />
                        </td>
                    </tr>
                </table>
                <br />
                <asp:Button ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />
                &nbsp;<asp:Button ID="DeleteButton" runat="server" CausesValidation="False" Text="Delete" OnClick ="ButtonDelete1_Click" />
            </ItemTemplate>
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
        </asp:FormView>
        <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [SinhVien] WHERE [MSSV] = @MSSV" InsertCommand="INSERT INTO [SinhVien] ([MSSV], [Password], [HoTen], [Email], [DiaChi]) VALUES (@MSSV, @Password, @HoTen, @Email, @DiaChi)" SelectCommand="SELECT * FROM [SinhVien] WHERE ([MSSV] = @MSSV)" UpdateCommand="UPDATE [SinhVien] SET [Password] = @Password, [HoTen] = @HoTen, [Email] = @Email, [DiaChi] = @DiaChi WHERE [MSSV] = @MSSV">
            <DeleteParameters>
                <asp:Parameter Name="MSSV" Type="String" />
            </DeleteParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="MSSV" PropertyName="Text" Type="String" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="DiaChi" Type="String" />
                <asp:Parameter Name="MSSV" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [GiangVien] WHERE [MSGV] = @MSGV" InsertCommand="INSERT INTO [GiangVien] ([MSGV], [Password], [HoTen]) VALUES (@MSGV, @Password, @HoTen)" SelectCommand="SELECT * FROM [GiangVien] WHERE ([MSGV] = @MSGV)" UpdateCommand="UPDATE [GiangVien] SET [Password] = @Password, [HoTen] = @HoTen WHERE [MSGV] = @MSGV">
            <DeleteParameters>
                <asp:Parameter Name="MSGV" Type="String" />
            </DeleteParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox2" Name="MSGV" PropertyName="Text" Type="String" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
                <asp:Parameter Name="MSGV" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:FormView ID="FormviewTimkiemGV" runat="server" DataKeyNames="MSGV" DataSourceID="SqlDataSource6" CellPadding="4" ForeColor="#333333">
            <EditItemTemplate>
                <table class="auto-style1">
                    <tr>
                        <td>MSGV</td>
                        <td>
                            <asp:Label ID="MSGVLabel1" runat="server" Text='<%# Eval("MSGV") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Password</td>
                        <td>
                            <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>HoTen</td>
                        <td>
                            <asp:TextBox ID="HoTenTextBox" runat="server" Text='<%# Bind("HoTen") %>' />
                        </td>
                    </tr>
                </table>
                <br />
                <asp:Button ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" />
                &nbsp;<asp:Button ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
            </EditItemTemplate>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <ItemTemplate>
                <table class="auto-style1">
                    <tr>
                        <td>MSGV</td>
                        <td>
                            <asp:Label ID="MSGVLabel" runat="server" Text='<%# Eval("MSGV") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>Password</td>
                        <td>
                            <asp:Label ID="PasswordLabel" runat="server" Text='<%# Bind("Password") %>' />
                        </td>
                    </tr>
                    <tr>
                        <td>HoTen</td>
                        <td>
                            <asp:Label ID="HoTenLabel" runat="server" Text='<%# Bind("HoTen") %>' />
                        </td>
                    </tr>
                </table>
                <br />
                <asp:Button ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" />
                &nbsp;<asp:Button ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" />
                &nbsp;
            </ItemTemplate>
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
        </asp:FormView>
        <br />
    </div>
    <div class ="Gridviews">
        <%--<asp:TemplateField HeaderText="STT">
                <ItemTemplate><%# Container.DataItemIndex +1 %></ItemTemplate>
                 </asp:TemplateField>--%>
        <div id ="Gr1">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="MSSV" DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display." AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="MSSV" HeaderText="MSSV" ReadOnly="True" SortExpression="MSSV" />
                <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                <asp:BoundField DataField="HoTen" HeaderText="HoTen" SortExpression="HoTen" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="DiaChi" HeaderText="DiaChi" SortExpression="DiaChi" />
                <asp:CommandField ButtonType="Button" ShowEditButton="True" />
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
            </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [SinhVien] WHERE [MSSV] = @MSSV" InsertCommand="INSERT INTO [SinhVien] ([MSSV], [Password], [HoTen], [Email], [DiaChi]) VALUES (@MSSV, @Password, @HoTen, @Email, @DiaChi)" ProviderName="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1.ProviderName %>" SelectCommand="SELECT [MSSV], [Password], [HoTen], [Email], [DiaChi] FROM [SinhVien]" UpdateCommand="UPDATE [SinhVien] SET [Password] = @Password, [HoTen] = @HoTen, [Email] = @Email, [DiaChi] = @DiaChi WHERE [MSSV] = @MSSV">
            <DeleteParameters>
                <asp:Parameter Name="MSSV" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="MSSV" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="DiaChi" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="DiaChi" Type="String" />
                <asp:Parameter Name="MSSV" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <div id ="Gr2">
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="MSGV" DataSourceID="SqlDataSource2" EmptyDataText="There are no data records to display." AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="MSGV" HeaderText="MSGV" ReadOnly="True" SortExpression="MSGV" />
                <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                <asp:BoundField DataField="HoTen" HeaderText="HoTen" SortExpression="HoTen" />
                <asp:CommandField ButtonType="Button" ShowEditButton="True" />
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
            </div>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [GiangVien] WHERE [MSGV] = @MSGV" InsertCommand="INSERT INTO [GiangVien] ([MSGV], [Password], [HoTen]) VALUES (@MSGV, @Password, @HoTen)" ProviderName="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1.ProviderName %>" SelectCommand="SELECT [MSGV], [Password], [HoTen] FROM [GiangVien]" UpdateCommand="UPDATE [GiangVien] SET [Password] = @Password, [HoTen] = @HoTen WHERE [MSGV] = @MSGV">
            <DeleteParameters>
                <asp:Parameter Name="MSGV" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="MSGV" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="HoTen" Type="String" />
                <asp:Parameter Name="MSGV" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <div id ="Gr3">
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource3" EmptyDataText="There are no data records to display." AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="Username" HeaderText="Username" SortExpression="Username" />
                <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="SoDT" HeaderText="SoDT" SortExpression="SoDT" />
                <asp:CommandField ButtonType="Button" ShowEditButton="True" />
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
            </div>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [PhongDaoTao] WHERE [ID] = @ID" InsertCommand="INSERT INTO [PhongDaoTao] ([ID], [Username], [Password], [Email], [SoDT]) VALUES (@ID, @Username, @Password, @Email, @SoDT)" ProviderName="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1.ProviderName %>" SelectCommand="SELECT [ID], [Username], [Password], [Email], [SoDT] FROM [PhongDaoTao]" UpdateCommand="UPDATE [PhongDaoTao] SET [Username] = @Username, [Password] = @Password, [Email] = @Email, [SoDT] = @SoDT WHERE [ID] = @ID">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="ID" Type="String" />
                <asp:Parameter Name="Username" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="SoDT" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Username" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="SoDT" Type="String" />
                <asp:Parameter Name="ID" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <div id ="Gr4">
        <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource4" EmptyDataText="There are no data records to display." CellPadding="4" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />
                <asp:BoundField DataField="Username" HeaderText="Username" SortExpression="Username" />
                <asp:BoundField DataField="Password" HeaderText="Password" SortExpression="Password" />
                <asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" />
                <asp:BoundField DataField="SoDT" HeaderText="SoDT" SortExpression="SoDT" />
                <asp:CommandField ButtonType="Button" ShowEditButton="True" />
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
            </div>
        <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1 %>" DeleteCommand="DELETE FROM [Admin] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Admin] ([ID], [Username], [Password], [Email], [SoDT]) VALUES (@ID, @Username, @Password, @Email, @SoDT)" ProviderName="<%$ ConnectionStrings:DanhGiaGiaoVienConnectionString1.ProviderName %>" SelectCommand="SELECT [ID], [Username], [Password], [Email], [SoDT] FROM [Admin]" UpdateCommand="UPDATE [Admin] SET [Username] = @Username, [Password] = @Password, [Email] = @Email, [SoDT] = @SoDT WHERE [ID] = @ID">
            <DeleteParameters>
                <asp:Parameter Name="ID" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="ID" Type="String" />
                <asp:Parameter Name="Username" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="SoDT" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Username" Type="String" />
                <asp:Parameter Name="Password" Type="String" />
                <asp:Parameter Name="Email" Type="String" />
                <asp:Parameter Name="SoDT" Type="String" />
                <asp:Parameter Name="ID" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />

        </div>


        <div class ="Formviews">

            <asp:FormView ID="FormView1" runat="server" DataKeyNames="MSSV" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333">
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <InsertItemTemplate>
                    <table class="auto-style1">
                        <tr>
                            <td>MSSV: </td>
                            <td>
                                <asp:TextBox ID="MSSVTextBox" runat="server" Text='<%# Bind("MSSV") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Password</td>
                            <td>
                                <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>HoTen</td>
                            <td>
                                <asp:TextBox ID="HoTenTextBox" runat="server" Text='<%# Bind("HoTen") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Email</td>
                            <td>
                                <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>DiaChi</td>
                            <td>
                                <asp:TextBox ID="DiaChiTextBox" runat="server" Text='<%# Bind("DiaChi") %>' />
                            </td>
                        </tr>
                    </table>
                    <br />
                    <asp:Button ID="InsertButton" runat="server" CausesValidation="True" Text="Insert" OnClick ="Button1_Click"/>
                    &nbsp;<asp:Button ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"  Text="Cancel" />
                </InsertItemTemplate>
                <ItemTemplate>
                   <asp:Button ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" Height="32px" Width="92px" />
                </ItemTemplate>
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
            </asp:FormView>
            <asp:FormView ID="FormView2" runat="server" DataKeyNames="MSGV" DataSourceID="SqlDataSource2" CellPadding="4" ForeColor="#333333" Width="30px">
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <InsertItemTemplate>
                    <table class="auto-style1">
                        <tr>
                            <td>MSGV</td>
                            <td>
                                <asp:TextBox ID="MSGVTextBox" runat="server" Text='<%# Bind("MSGV") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Password</td>
                            <td>
                                <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>HoTen</td>
                            <td>
                                <asp:TextBox ID="HoTenTextBox" runat="server" Text='<%# Bind("HoTen") %>' />
                            </td>
                        </tr>
                    </table>
                    <br />
                    <asp:Button ID="InsertButton" runat="server" CausesValidation="True"  OnClick="Button2_Click" Text="Insert" />
                    &nbsp;<asp:Button ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                </InsertItemTemplate>
                <ItemTemplate>
                    <asp:Button ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" Height="28px" Width="93px" />
                </ItemTemplate>
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
            </asp:FormView>
            <asp:FormView ID="FormView3" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource3" CellPadding="4" ForeColor="#333333">
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <InsertItemTemplate>
                    <table class="auto-style1">
                        <tr>
                            <td>ID</td>
                            <td>
                                <asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("ID") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>UserName</td>
                            <td>
                                <asp:TextBox ID="UsernameTextBox" runat="server" Text='<%# Bind("Username") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Password</td>
                            <td>
                                <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Email</td>
                            <td>
                                <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>SoDT</td>
                            <td>
                                <asp:TextBox ID="SoDTTextBox" runat="server" Text='<%# Bind("SoDT") %>' />
                            </td>
                        </tr>
                    </table>
                    <br />
                    <asp:Button ID="InsertButton" runat="server" CausesValidation="True" OnClick="Button3_Click" Text="Insert" />
                    &nbsp;<asp:Button ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                </InsertItemTemplate>
                <ItemTemplate>
                    <asp:Button ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" Height="26px" Width="93px" />
                </ItemTemplate>
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
            </asp:FormView>
            <asp:FormView ID="FormView4" runat="server" DataKeyNames="ID" DataSourceID="SqlDataSource4" CellPadding="4" ForeColor="#333333">
                <EditRowStyle BackColor="#7C6F57" />
                <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                <InsertItemTemplate>
                    <table class="auto-style1">
                        <tr>
                            <td>ID</td>
                            <td>
                                <asp:TextBox ID="IDTextBox" runat="server" Text='<%# Bind("ID") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Username</td>
                            <td>
                                <asp:TextBox ID="UsernameTextBox" runat="server" Text='<%# Bind("Username") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Password</td>
                            <td>
                                <asp:TextBox ID="PasswordTextBox" runat="server" Text='<%# Bind("Password") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>Email</td>
                            <td>
                                <asp:TextBox ID="EmailTextBox" runat="server" Text='<%# Bind("Email") %>' />
                            </td>
                        </tr>
                        <tr>
                            <td>SoDT</td>
                            <td>
                                <asp:TextBox ID="SoDTTextBox" runat="server" Text='<%# Bind("SoDT") %>' />
                            </td>
                        </tr>
                    </table>
                    <br />
                    <asp:Button ID="InsertButton" runat="server" CausesValidation="True"  Text="Insert" OnClick="Button4_Click" />
                    &nbsp;<asp:Button ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" />
                </InsertItemTemplate>
                <ItemTemplate>
                    &nbsp;<asp:Button ID="NewButton" runat="server" CausesValidation="False" CommandName="New" Text="New" Height="26px" Width="87px" />
                </ItemTemplate>
                <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#E3EAEB" />
            </asp:FormView>

        </div>
</asp:Content>

